<?php 
	error_reporting(E_WARNING);
	include_once 'metodos.php';
	include_once 'conexao.php';
?>
<head>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/themes/base/jquery.ui.all.css">
	<script src="jquery-ui-1.8.16.custom/development-bundle/jquery-1.6.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.datepicker.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/external/jquery.bgiframe-2.1.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.mouse.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.draggable.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.position.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.resizable.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.dialog.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.button.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.effects.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js"></script>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/demos/demos.css">

	<style>
		body { font-size: 62.5%; }
		label, input { display:block; }
		input.text { margin-bottom:12px; width:95%; padding: .4em; }
		fieldset { padding:0; border:0; margin-top:25px; }
		h1 { font-size: 1.2em; margin: .6em 0; }
		div#users-contain { width: 350px; margin: 20px 0; }
		div#users-contain table { margin: 1em 0; border-collapse: collapse; width: 100%; }
		div#users-contain table td, div#users-contain table th { border: 1px solid #eee; padding: .6em 10px; text-align: left; }
		.ui-dialog .ui-state-error { padding: .3em; }
		.validateTips { border: 1px solid transparent; padding: 0.3em; }
	</style>

	<script>
	$(function() {
		$( "#datepicker" ).datepicker();
	});
	</script>

	<script>
	$(function() {
		// a workaround for a flaw in the demo system (http://dev.jqueryui.com/ticket/4375), ignore!
		$( "#dialog:ui-dialog" ).dialog( "destroy" );
		
		var name = $( "#name" ),
			email = $( "#email" ),
			password = $( "#password" ),
			allFields = $( [] ).add( name ).add( email ).add( password ),
			tips = $( ".validateTips" );

		function updateTips( t ) {
			tips
				.text( t )
				.addClass( "ui-state-highlight" );
			setTimeout(function() {
				tips.removeClass( "ui-state-highlight", 1500 );
			}, 500 );
		}

		function checkLength( o, n, min, max ) {
			if ( o.val().length > max || o.val().length < min ) {
				o.addClass( "ui-state-error" );
				updateTips( "Length of " + n + " must be between " +
					min + " and " + max + "." );
				return false;
			} else {
				return true;
			}
		}

		function checkRegexp( o, regexp, n ) {
			if ( !( regexp.test( o.val() ) ) ) {
				o.addClass( "ui-state-error" );
				updateTips( n );
				return false;
			} else {
				return true;
			}
		}
		
		$( "#dialog-form" ).dialog({
			autoOpen: false,
			height: 170,
			width: 180,
			modal: true,
			buttons: {
				"Marcar": function() {
					var bValid = true;
					allFields.removeClass( "ui-state-error" );

					bValid = bValid && checkLength( name, "username", 3, 16 );
					bValid = bValid && checkLength( email, "email", 6, 80 );
					bValid = bValid && checkLength( password, "password", 5, 16 );

					bValid = bValid && checkRegexp( name, /^[a-z]([0-9a-z_])+$/i, "Username may consist of a-z, 0-9, underscores, begin with a letter." );
					// From jquery.validate.js (by joern), contributed by Scott Gonzalez: http://projects.scottsplayground.com/email_address_validation/
					bValid = bValid && checkRegexp( email, /^((([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i, "eg. ui@jquery.com" );
					bValid = bValid && checkRegexp( password, /^([0-9a-zA-Z])+$/, "Password field only allow : a-z 0-9" );

					if ( bValid ) {
						$( "#users tbody" ).append( "<tr>" +
							"<td>" + name.val() + "</td>" + 
							"<td>" + email.val() + "</td>" + 
							"<td>" + password.val() + "</td>" +
						"</tr>" ); 
						$( this ).dialog( "close" );
					}
				},
				Cancelan: function() {
					$( this ).dialog( "close" );
				}
			},
			close: function() {
				allFields.val( "" ).removeClass( "ui-state-error" );
			}
		});

		$( ".create-user" )
			.button()
			.click(function() {
				$( "#dialog-form" ).dialog( "open" );
			});
	});
	</script>
</head>

<script language="Javascript">
	function popup(){
		window.open('http://localhost/SGP/lixo/popup.php','janela','toolbar=no,location=no, directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,menubar=no,width=315,height=80' );
	}
</script>


<form action="agenda.php" method="post">
<span>Agenda de </span>
<SELECT name="podo">
	<?php 
	$sql = mysql_query("SELECT * FROM tb_funcionario");
	while ($row = mysql_fetch_array($sql)){
		echo '<OPTION value="'.$row['id'].'">'.$row['nome'].' '.$row['sobrenome'].'</OPTION>';
	}
	?>
</SELECT>
<input type="hidden" name="cmd" value="agenda">
Data: <input type="text" id="datepicker" name="data">
<input type="submit" value="Buscar">
</form>
<hr>
	
	<?php 
	if(isset($_POST['cmd']) || $_POST['cmd']=='agenda'){
		$query = mysql_query("SELECT * FROM tb_cliente");
		//autocomplite de clientes
		?>
		<script>
	$(function() {
		var availableTags = [
			<?php 
				while ($row_cliente = mysql_fetch_array($query)){
					echo '"'.utf8_encode($row_cliente['nome']).' '.utf8_encode($row_cliente['sobrenome']).'",';
					//echo '"<imput name=\"cliente\" value=\"'.$row_cliente['id'].'\"/> ",';	
				}
			?>
		];
		$( "#tags" ).autocomplete({
			source: availableTags
		});
	});
	</script>
		<?php 
				
		//formulario para marcar agenda
		?>
		<div id="dialog-form" title="Marcar Agenda">
			<form>
			<fieldset>
				<label for="name">Nome</label>
				<input id="tags"/>
			</fieldset>
			</form>
		</div>
		
		<?php
		
		$c = 1;
		$hora = array(1=>'08:00',2=>'08:40', 3=>'09:20',4=>'10:00',5=>'10:40', 6=>'11:20',7=>'12:00', 8=>'12:40', 9=>'13:20', 10=>'14:00', 11=>'14:40'
						, 12=>'15:20', 13=>'16:00', 14=>'16:40', 15=>'17:20', 16=>'18:00');

		if(empty($_POST['data'])){
			$data=date("Y-m-d");
		}else{
			$data = $_POST['data'];
		}
		//Criando os horarios
		echo '<table>';
		while ($c<17){
			echo '<tr><td width="50px"><strong>'.$hora[$c].'</strong></td>';
			$agenda = mysql_query("SELECT * FROM tb_agenda a, tb_cliente c WHERE a.hora='".$hora[$c].":00' AND a.data='".$data."' AND a.id_cliente=c.id AND a.id_funcionario=".$_POST['podo']. " ORDER BY a.hora LIMIT 1");
			$num = mysql_num_rows($agenda);
			if($num>0){
			$row = mysql_fetch_array($agenda);
			echo '<td>'.utf8_encode($row['nome']).' '.utf8_encode($row['sobrenome']).'</td></tr>';
			}else{
				echo '<td style="color: red; width: 100px"> Vago <button class="create-user"> Marcar </button></td>';
			}
			++$c;
		}
		echo '</table>';
	}
?>